Members of the Sysadmin Role

Issue

The members of the Sysadmin server role should be kept to a minimum because this role gives system administrator rights to all its members.

Solution

Review the members of the sysadmin role. Ensure that each of these members should have system administrator rights to the SQL Server. 

Important: If you are running Small Business Server (SBS) 2000, you will need at least one local Administrator account in the sysadmin server role to use SQL Enterprise Manager on the server.

Instructions

To review the Sysadmin members:

1. Click Start, point to Programs, point to Microsoft SQL Server, and then click Enterprise Manager.
2. In SQL Server Enterprise Manager, double-click SQL Server Group, and then double-click the SQL Server that you want to secure.
3. Click the Security folder, click Server Roles, and then double-click the System Administrators role in the right pane.

Additional Information

SQL Server 7.0 Security

Microsoft SQL Server 2000 Security

⌐ 2002 Microsoft Corporation. All rights reserved.